﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DsVacations" targetNamespace="http://tempuri.org/DsVacations.xsd" xmlns:mstns="http://tempuri.org/DsVacations.xsd" xmlns="http://tempuri.org/DsVacations.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="RundConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="RundConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.OasisIBS.My.MySettings.GlobalReference.Default.RundConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="Oasis_IBS_IndemnityConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Oasis_IBS_IndemnityConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.OasisIBS.My.MySettings.GlobalReference.Default.Oasis_IBS_IndemnityConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables />
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DsVacations" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DsVacations" msprop:Generator_UserDSName="DsVacations">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="StaffLeave" msprop:Generator_TableClassName="StaffLeaveDataTable" msprop:Generator_TableVarName="tableStaffLeave" msprop:Generator_RowChangedName="StaffLeaveRowChanged" msprop:Generator_TablePropName="StaffLeave" msprop:Generator_RowDeletingName="StaffLeaveRowDeleting" msprop:Generator_RowChangingName="StaffLeaveRowChanging" msprop:Generator_RowEvHandlerName="StaffLeaveRowChangeEventHandler" msprop:Generator_RowDeletedName="StaffLeaveRowDeleted" msprop:Generator_RowClassName="StaffLeaveRow" msprop:Generator_UserTableName="StaffLeave" msprop:Generator_RowEvArgName="StaffLeaveRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SNo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSNo" msprop:Generator_ColumnPropNameInRow="SNo" msprop:Generator_ColumnPropNameInTable="SNoColumn" msprop:Generator_UserColumnName="SNo" type="xs:int" />
              <xs:element name="EmpID" msprop:Generator_ColumnVarNameInTable="columnEmpID" msprop:Generator_ColumnPropNameInRow="EmpID" msprop:Generator_ColumnPropNameInTable="EmpIDColumn" msprop:Generator_UserColumnName="EmpID" type="xs:int" minOccurs="0" />
              <xs:element name="EmpName" msprop:Generator_ColumnVarNameInTable="columnEmpName" msprop:Generator_ColumnPropNameInRow="EmpName" msprop:Generator_ColumnPropNameInTable="EmpNameColumn" msprop:Generator_UserColumnName="EmpName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PeriodFrom" msprop:Generator_ColumnVarNameInTable="columnPeriodFrom" msprop:Generator_ColumnPropNameInRow="PeriodFrom" msprop:Generator_ColumnPropNameInTable="PeriodFromColumn" msprop:Generator_UserColumnName="PeriodFrom" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PeriodTo" msprop:Generator_ColumnVarNameInTable="columnPeriodTo" msprop:Generator_ColumnPropNameInRow="PeriodTo" msprop:Generator_ColumnPropNameInTable="PeriodToColumn" msprop:Generator_UserColumnName="PeriodTo" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NoOfDays" msprop:Generator_ColumnVarNameInTable="columnNoOfDays" msprop:Generator_ColumnPropNameInRow="NoOfDays" msprop:Generator_ColumnPropNameInTable="NoOfDaysColumn" msprop:Generator_UserColumnName="NoOfDays" type="xs:int" minOccurs="0" />
              <xs:element name="LeaveReson" msprop:Generator_ColumnVarNameInTable="columnLeaveReson" msprop:Generator_ColumnPropNameInRow="LeaveReson" msprop:Generator_ColumnPropNameInTable="LeaveResonColumn" msprop:Generator_UserColumnName="LeaveReson" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactDetails" msprop:Generator_ColumnVarNameInTable="columnContactDetails" msprop:Generator_ColumnPropNameInRow="ContactDetails" msprop:Generator_ColumnPropNameInTable="ContactDetailsColumn" msprop:Generator_UserColumnName="ContactDetails" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SavedBy" msprop:Generator_ColumnVarNameInTable="columnSavedBy" msprop:Generator_ColumnPropNameInRow="SavedBy" msprop:Generator_ColumnPropNameInTable="SavedByColumn" msprop:Generator_UserColumnName="SavedBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransDate" msprop:Generator_ColumnVarNameInTable="columnTransDate" msprop:Generator_ColumnPropNameInRow="TransDate" msprop:Generator_ColumnPropNameInTable="TransDateColumn" msprop:Generator_UserColumnName="TransDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="StaffProfiles" msprop:Generator_TableClassName="StaffProfilesDataTable" msprop:Generator_TableVarName="tableStaffProfiles" msprop:Generator_TablePropName="StaffProfiles" msprop:Generator_RowDeletingName="StaffProfilesRowDeleting" msprop:Generator_RowChangingName="StaffProfilesRowChanging" msprop:Generator_RowEvHandlerName="StaffProfilesRowChangeEventHandler" msprop:Generator_RowDeletedName="StaffProfilesRowDeleted" msprop:Generator_UserTableName="StaffProfiles" msprop:Generator_RowChangedName="StaffProfilesRowChanged" msprop:Generator_RowEvArgName="StaffProfilesRowChangeEvent" msprop:Generator_RowClassName="StaffProfilesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EmpNo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnEmpNo" msprop:Generator_ColumnPropNameInRow="EmpNo" msprop:Generator_ColumnPropNameInTable="EmpNoColumn" msprop:Generator_UserColumnName="EmpNo" type="xs:int" />
              <xs:element name="FullNameEn" msprop:Generator_ColumnVarNameInTable="columnFullNameEn" msprop:Generator_ColumnPropNameInRow="FullNameEn" msprop:Generator_ColumnPropNameInTable="FullNameEnColumn" msprop:Generator_UserColumnName="FullNameEn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullNameAr" msprop:Generator_ColumnVarNameInTable="columnFullNameAr" msprop:Generator_ColumnPropNameInRow="FullNameAr" msprop:Generator_ColumnPropNameInTable="FullNameArColumn" msprop:Generator_UserColumnName="FullNameAr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaritalStatus" msprop:Generator_ColumnVarNameInTable="columnMaritalStatus" msprop:Generator_ColumnPropNameInRow="MaritalStatus" msprop:Generator_ColumnPropNameInTable="MaritalStatusColumn" msprop:Generator_UserColumnName="MaritalStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nationality" msprop:Generator_ColumnVarNameInTable="columnNationality" msprop:Generator_ColumnPropNameInRow="Nationality" msprop:Generator_ColumnPropNameInTable="NationalityColumn" msprop:Generator_UserColumnName="Nationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReligionEn" msprop:Generator_ColumnVarNameInTable="columnReligionEn" msprop:Generator_ColumnPropNameInRow="ReligionEn" msprop:Generator_ColumnPropNameInTable="ReligionEnColumn" msprop:Generator_UserColumnName="ReligionEn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnPropNameInTable="GenderColumn" msprop:Generator_UserColumnName="Gender" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Admin" msprop:Generator_ColumnVarNameInTable="columnAdmin" msprop:Generator_ColumnPropNameInRow="Admin" msprop:Generator_ColumnPropNameInTable="AdminColumn" msprop:Generator_UserColumnName="Admin" type="xs:int" minOccurs="0" />
              <xs:element name="DateofBirth" msprop:Generator_ColumnVarNameInTable="columnDateofBirth" msprop:Generator_ColumnPropNameInRow="DateofBirth" msprop:Generator_ColumnPropNameInTable="DateofBirthColumn" msprop:Generator_UserColumnName="DateofBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mobile" msprop:Generator_ColumnVarNameInTable="columnMobile" msprop:Generator_ColumnPropNameInRow="Mobile" msprop:Generator_ColumnPropNameInTable="MobileColumn" msprop:Generator_UserColumnName="Mobile" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GOSINo" msprop:Generator_ColumnVarNameInTable="columnGOSINo" msprop:Generator_ColumnPropNameInRow="GOSINo" msprop:Generator_ColumnPropNameInTable="GOSINoColumn" msprop:Generator_UserColumnName="GOSINo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sponsor" msprop:Generator_ColumnVarNameInTable="columnSponsor" msprop:Generator_ColumnPropNameInRow="Sponsor" msprop:Generator_ColumnPropNameInTable="SponsorColumn" msprop:Generator_UserColumnName="Sponsor" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Position" msprop:Generator_ColumnVarNameInTable="columnPosition" msprop:Generator_ColumnPropNameInRow="Position" msprop:Generator_ColumnPropNameInTable="PositionColumn" msprop:Generator_UserColumnName="Position" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HireDate" msprop:Generator_ColumnVarNameInTable="columnHireDate" msprop:Generator_ColumnPropNameInRow="HireDate" msprop:Generator_ColumnPropNameInTable="HireDateColumn" msprop:Generator_UserColumnName="HireDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VacationPeriod" msprop:Generator_ColumnVarNameInTable="columnVacationPeriod" msprop:Generator_ColumnPropNameInRow="VacationPeriod" msprop:Generator_ColumnPropNameInTable="VacationPeriodColumn" msprop:Generator_UserColumnName="VacationPeriod" type="xs:double" minOccurs="0" />
              <xs:element name="Branch" msprop:Generator_ColumnVarNameInTable="columnBranch" msprop:Generator_ColumnPropNameInRow="Branch" msprop:Generator_ColumnPropNameInTable="BranchColumn" msprop:Generator_UserColumnName="Branch" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDNo" msprop:Generator_ColumnVarNameInTable="columnIDNo" msprop:Generator_ColumnPropNameInRow="IDNo" msprop:Generator_ColumnPropNameInTable="IDNoColumn" msprop:Generator_UserColumnName="IDNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDIssuePlace" msprop:Generator_ColumnVarNameInTable="columnIDIssuePlace" msprop:Generator_ColumnPropNameInRow="IDIssuePlace" msprop:Generator_ColumnPropNameInTable="IDIssuePlaceColumn" msprop:Generator_UserColumnName="IDIssuePlace" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDIssuePlaceAr" msprop:Generator_ColumnVarNameInTable="columnIDIssuePlaceAr" msprop:Generator_ColumnPropNameInRow="IDIssuePlaceAr" msprop:Generator_ColumnPropNameInTable="IDIssuePlaceArColumn" msprop:Generator_UserColumnName="IDIssuePlaceAr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDIssueDate" msprop:Generator_ColumnVarNameInTable="columnIDIssueDate" msprop:Generator_ColumnPropNameInRow="IDIssueDate" msprop:Generator_ColumnPropNameInTable="IDIssueDateColumn" msprop:Generator_UserColumnName="IDIssueDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IDExDate" msprop:Generator_ColumnVarNameInTable="columnIDExDate" msprop:Generator_ColumnPropNameInRow="IDExDate" msprop:Generator_ColumnPropNameInTable="IDExDateColumn" msprop:Generator_UserColumnName="IDExDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PassportNo" msprop:Generator_ColumnVarNameInTable="columnPassportNo" msprop:Generator_ColumnPropNameInRow="PassportNo" msprop:Generator_ColumnPropNameInTable="PassportNoColumn" msprop:Generator_UserColumnName="PassportNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassIssuePlace" msprop:Generator_ColumnVarNameInTable="columnPassIssuePlace" msprop:Generator_ColumnPropNameInRow="PassIssuePlace" msprop:Generator_ColumnPropNameInTable="PassIssuePlaceColumn" msprop:Generator_UserColumnName="PassIssuePlace" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassIssuePlaceAr" msprop:Generator_ColumnVarNameInTable="columnPassIssuePlaceAr" msprop:Generator_ColumnPropNameInRow="PassIssuePlaceAr" msprop:Generator_ColumnPropNameInTable="PassIssuePlaceArColumn" msprop:Generator_UserColumnName="PassIssuePlaceAr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassIssueDate" msprop:Generator_ColumnVarNameInTable="columnPassIssueDate" msprop:Generator_ColumnPropNameInRow="PassIssueDate" msprop:Generator_ColumnPropNameInTable="PassIssueDateColumn" msprop:Generator_UserColumnName="PassIssueDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ExDate" msprop:Generator_ColumnVarNameInTable="columnExDate" msprop:Generator_ColumnPropNameInRow="ExDate" msprop:Generator_ColumnPropNameInTable="ExDateColumn" msprop:Generator_UserColumnName="ExDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DoctorName" msprop:Generator_ColumnVarNameInTable="columnDoctorName" msprop:Generator_ColumnPropNameInRow="DoctorName" msprop:Generator_ColumnPropNameInTable="DoctorNameColumn" msprop:Generator_UserColumnName="DoctorName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DoctorAddress" msprop:Generator_ColumnVarNameInTable="columnDoctorAddress" msprop:Generator_ColumnPropNameInRow="DoctorAddress" msprop:Generator_ColumnPropNameInTable="DoctorAddressColumn" msprop:Generator_UserColumnName="DoctorAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DoctorPhoneNo" msprop:Generator_ColumnVarNameInTable="columnDoctorPhoneNo" msprop:Generator_ColumnPropNameInRow="DoctorPhoneNo" msprop:Generator_ColumnPropNameInTable="DoctorPhoneNoColumn" msprop:Generator_UserColumnName="DoctorPhoneNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BloodType" msprop:Generator_ColumnVarNameInTable="columnBloodType" msprop:Generator_ColumnPropNameInRow="BloodType" msprop:Generator_ColumnPropNameInTable="BloodTypeColumn" msprop:Generator_UserColumnName="BloodType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MedicalConditions" msprop:Generator_ColumnVarNameInTable="columnMedicalConditions" msprop:Generator_ColumnPropNameInRow="MedicalConditions" msprop:Generator_ColumnPropNameInTable="MedicalConditionsColumn" msprop:Generator_UserColumnName="MedicalConditions" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Allergies" msprop:Generator_ColumnVarNameInTable="columnAllergies" msprop:Generator_ColumnPropNameInRow="Allergies" msprop:Generator_ColumnPropNameInTable="AllergiesColumn" msprop:Generator_UserColumnName="Allergies" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrentMedications" msprop:Generator_ColumnVarNameInTable="columnCurrentMedications" msprop:Generator_ColumnPropNameInRow="CurrentMedications" msprop:Generator_ColumnPropNameInTable="CurrentMedicationsColumn" msprop:Generator_UserColumnName="CurrentMedications" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmergContactName" msprop:Generator_ColumnVarNameInTable="columnEmergContactName" msprop:Generator_ColumnPropNameInRow="EmergContactName" msprop:Generator_ColumnPropNameInTable="EmergContactNameColumn" msprop:Generator_UserColumnName="EmergContactName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmergContactRelationship" msprop:Generator_ColumnVarNameInTable="columnEmergContactRelationship" msprop:Generator_ColumnPropNameInRow="EmergContactRelationship" msprop:Generator_ColumnPropNameInTable="EmergContactRelationshipColumn" msprop:Generator_UserColumnName="EmergContactRelationship" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmergContactAddress" msprop:Generator_ColumnVarNameInTable="columnEmergContactAddress" msprop:Generator_ColumnPropNameInRow="EmergContactAddress" msprop:Generator_ColumnPropNameInTable="EmergContactAddressColumn" msprop:Generator_UserColumnName="EmergContactAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmergContactPhone" msprop:Generator_ColumnVarNameInTable="columnEmergContactPhone" msprop:Generator_ColumnPropNameInRow="EmergContactPhone" msprop:Generator_ColumnPropNameInTable="EmergContactPhoneColumn" msprop:Generator_UserColumnName="EmergContactPhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SalaryBS" msprop:Generator_ColumnVarNameInTable="columnSalaryBS" msprop:Generator_ColumnPropNameInRow="SalaryBS" msprop:Generator_ColumnPropNameInTable="SalaryBSColumn" msprop:Generator_UserColumnName="SalaryBS" type="xs:double" minOccurs="0" />
              <xs:element name="SalaryHA" msprop:Generator_ColumnVarNameInTable="columnSalaryHA" msprop:Generator_ColumnPropNameInRow="SalaryHA" msprop:Generator_ColumnPropNameInTable="SalaryHAColumn" msprop:Generator_UserColumnName="SalaryHA" type="xs:double" minOccurs="0" />
              <xs:element name="SalaryTA" msprop:Generator_ColumnVarNameInTable="columnSalaryTA" msprop:Generator_ColumnPropNameInRow="SalaryTA" msprop:Generator_ColumnPropNameInTable="SalaryTAColumn" msprop:Generator_UserColumnName="SalaryTA" type="xs:double" minOccurs="0" />
              <xs:element name="SalaryFuel" msprop:Generator_ColumnVarNameInTable="columnSalaryFuel" msprop:Generator_ColumnPropNameInRow="SalaryFuel" msprop:Generator_ColumnPropNameInTable="SalaryFuelColumn" msprop:Generator_UserColumnName="SalaryFuel" type="xs:double" minOccurs="0" />
              <xs:element name="SalarySupervision" msprop:Generator_ColumnVarNameInTable="columnSalarySupervision" msprop:Generator_ColumnPropNameInRow="SalarySupervision" msprop:Generator_ColumnPropNameInTable="SalarySupervisionColumn" msprop:Generator_UserColumnName="SalarySupervision" type="xs:double" minOccurs="0" />
              <xs:element name="SalaryTuitionFees" msprop:Generator_ColumnVarNameInTable="columnSalaryTuitionFees" msprop:Generator_ColumnPropNameInRow="SalaryTuitionFees" msprop:Generator_ColumnPropNameInTable="SalaryTuitionFeesColumn" msprop:Generator_UserColumnName="SalaryTuitionFees" type="xs:double" minOccurs="0" />
              <xs:element name="SalaryMobile" msprop:Generator_ColumnVarNameInTable="columnSalaryMobile" msprop:Generator_ColumnPropNameInRow="SalaryMobile" msprop:Generator_ColumnPropNameInTable="SalaryMobileColumn" msprop:Generator_UserColumnName="SalaryMobile" type="xs:double" minOccurs="0" />
              <xs:element name="Others" msprop:Generator_ColumnVarNameInTable="columnOthers" msprop:Generator_ColumnPropNameInRow="Others" msprop:Generator_ColumnPropNameInTable="OthersColumn" msprop:Generator_UserColumnName="Others" type="xs:double" minOccurs="0" />
              <xs:element name="TotalSalary" msprop:Generator_ColumnVarNameInTable="columnTotalSalary" msprop:Generator_ColumnPropNameInRow="TotalSalary" msprop:Generator_ColumnPropNameInTable="TotalSalaryColumn" msprop:Generator_UserColumnName="TotalSalary" type="xs:double" minOccurs="0" />
              <xs:element name="Photo" msprop:Generator_ColumnVarNameInTable="columnPhoto" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_UserColumnName="Photo" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="EndOfServiceDate" msprop:Generator_ColumnVarNameInTable="columnEndOfServiceDate" msprop:Generator_ColumnPropNameInRow="EndOfServiceDate" msprop:Generator_ColumnPropNameInTable="EndOfServiceDateColumn" msprop:Generator_UserColumnName="EndOfServiceDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndOfServiceType" msprop:Generator_ColumnVarNameInTable="columnEndOfServiceType" msprop:Generator_ColumnPropNameInRow="EndOfServiceType" msprop:Generator_ColumnPropNameInTable="EndOfServiceTypeColumn" msprop:Generator_UserColumnName="EndOfServiceType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EndOfServiceSalary" msprop:Generator_ColumnVarNameInTable="columnEndOfServiceSalary" msprop:Generator_ColumnPropNameInRow="EndOfServiceSalary" msprop:Generator_ColumnPropNameInTable="EndOfServiceSalaryColumn" msprop:Generator_UserColumnName="EndOfServiceSalary" type="xs:double" minOccurs="0" />
              <xs:element name="HiredYears" msprop:Generator_ColumnVarNameInTable="columnHiredYears" msprop:Generator_ColumnPropNameInRow="HiredYears" msprop:Generator_ColumnPropNameInTable="HiredYearsColumn" msprop:Generator_UserColumnName="HiredYears" type="xs:double" minOccurs="0" />
              <xs:element name="HiredMonths" msprop:Generator_ColumnVarNameInTable="columnHiredMonths" msprop:Generator_ColumnPropNameInRow="HiredMonths" msprop:Generator_ColumnPropNameInTable="HiredMonthsColumn" msprop:Generator_UserColumnName="HiredMonths" type="xs:double" minOccurs="0" />
              <xs:element name="EndOfServiceBenefits" msprop:Generator_ColumnVarNameInTable="columnEndOfServiceBenefits" msprop:Generator_ColumnPropNameInRow="EndOfServiceBenefits" msprop:Generator_ColumnPropNameInTable="EndOfServiceBenefitsColumn" msprop:Generator_UserColumnName="EndOfServiceBenefits" type="xs:double" minOccurs="0" />
              <xs:element name="EndOfServiceBenefitsWritten" msprop:Generator_ColumnVarNameInTable="columnEndOfServiceBenefitsWritten" msprop:Generator_ColumnPropNameInRow="EndOfServiceBenefitsWritten" msprop:Generator_ColumnPropNameInTable="EndOfServiceBenefitsWrittenColumn" msprop:Generator_UserColumnName="EndOfServiceBenefitsWritten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comments" msprop:Generator_ColumnVarNameInTable="columnComments" msprop:Generator_ColumnPropNameInRow="Comments" msprop:Generator_ColumnPropNameInTable="CommentsColumn" msprop:Generator_UserColumnName="Comments" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EndedBy" msprop:Generator_ColumnVarNameInTable="columnEndedBy" msprop:Generator_ColumnPropNameInRow="EndedBy" msprop:Generator_ColumnPropNameInTable="EndedByColumn" msprop:Generator_UserColumnName="EndedBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EndedOn" msprop:Generator_ColumnVarNameInTable="columnEndedOn" msprop:Generator_ColumnPropNameInRow="EndedOn" msprop:Generator_ColumnPropNameInTable="EndedOnColumn" msprop:Generator_UserColumnName="EndedOn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StaffLeave" />
      <xs:field xpath="mstns:SNo" />
    </xs:unique>
    <xs:unique name="StaffProfiles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StaffProfiles" />
      <xs:field xpath="mstns:EmpNo" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="StaffProfiles_StaffLeave" msdata:parent="StaffProfiles" msdata:child="StaffLeave" msdata:parentkey="EmpNo" msdata:childkey="EmpID" msprop:Generator_UserChildTable="StaffLeave" msprop:Generator_ChildPropName="GetStaffLeaveRows" msprop:Generator_UserRelationName="StaffProfiles_StaffLeave" msprop:Generator_RelationVarName="relationStaffProfiles_StaffLeave" msprop:Generator_UserParentTable="StaffProfiles" msprop:Generator_ParentPropName="StaffProfilesRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>